<?xml version="1.0" encoding="ISO-8859-1" ?>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Insert title here</title>
</head>
<body>
	<%@ page import="java.sql.*"%>
	<%
		int id = Integer.parseInt(request.getParameter("id"));
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		Connection con;
		con = DriverManager.getConnection(
				"jdbc:sqlserver://localhost:1510;databaseName=clientes",
				"sa", "cenec");

		String query = "delete from clientes where id=?";

		PreparedStatement pst = con.prepareStatement(query);

		pst.setInt(1, id);

		pst.executeUpdate();

		response.sendRedirect("clientesObj.jsp");
	%>
</body>
</html>